﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

/// <summary>
/// Summary description for ExcelUtil
/// </summary>
namespace WebTeamplate
{
    public class ExcelUtil
    {
        public ExcelUtil()
        {
            //
            // TODO: Add constructor logic here
            //
        }
        public static string CreateCellBorder()
        {
            string result = string.Empty;
            int borderWidth = 1;
            string lineStyle = "Continuous";
            result += "<Borders>\r\n";
            result += "   <Border ss:Position='Bottom' ss:LineStyle='" + lineStyle + "' ss:Weight='" + borderWidth.ToString() + "'/>\r\n";
            result += "   <Border ss:Position='Left' ss:LineStyle='" + lineStyle + "' ss:Weight='" + borderWidth.ToString() + "'/>\r\n";
            result += "   <Border ss:Position='Right' ss:LineStyle='" + lineStyle + "' ss:Weight='" + borderWidth.ToString() + "'/>\r\n";
            result += "   <Border ss:Position='Top' ss:LineStyle='" + lineStyle + "' ss:Weight='" + borderWidth.ToString() + "'/>\r\n";
            result += "</Borders>\r\n";
            return result;
        }
    }
}
